Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# SESSIONTIMEZONE

Syntax

Description of the illustration sessiontimezone.gif

Purpose

`SESSIONTIMEZONE` returns the time zone of the current session. The return type is a time zone offset (a character type in the format `'[+|]TZH:TZM'`) or a time zone region name, depending on how the user specified the session time zone value in the most recent `ALTER` `SESSION` statement.

Note: You can set the default client session time zone using the `ORA_SDTZ` environment variable. Please refer to Oracle Database Globalization Support Guide for more information on this variable.

Examples

The following example returns the time zone of the current session:

    SELECT SESSIONTIMEZONE FROM DUAL;

    SESSION
    -------
    -08:00